<?php

class CreateItems extends Ruckusing_BaseMigration {

	public function up() {
    $sql = <<<SQL
create table items (
  id int(11) not null auto_increment,
  code varchar(255) not null default '',
  description text,
  image_url varchar(255) not null default '',
  price decimal(10,2) not null default 0,
  primary key (id)
)
SQL;
    $this->execute($sql);
	}//up()

	public function down() {
    $this->drop_table('items');
	}//down()
}
?>
